package com.webmagic.house.mapper;

import com.webmagic.house.bean.House;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface HouseMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(House record);

    int insertSelective(House record);

    House selectByPrimaryKey(Integer id);
    @Select("select * from house where building_id = #{buildingId} order by house_floor asc")
    List<House> selectByBuildingId(@Param("buildingId") String buildingId);

    int updateByPrimaryKeySelective(House record);

    int updateByPrimaryKey(House record);
}